Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_VIEWS

`ALL_VIEWS` describes the views accessible to the current user.

Related Views

- `DBA_VIEWS` describes all views in the database.

- `USER_VIEWS` describes the views owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the view
`VIEW_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the view
`TEXT_LENGTH` | `NUMBER` |  | Length of the view text
`TEXT` | `LONG` |  | View text
`TYPE_TEXT_LENGTH` | `NUMBER` |  | Length of the type clause of the typed view
`TYPE_TEXT` | `VARCHAR2(4000)` |  | Type clause of the typed view
`OID_TEXT_LENGTH` | `NUMBER` |  | Length of the `WITH OID` clause of the typed view
`OID_TEXT` | `VARCHAR2(4000)` |  | `WITH OID` clause of the typed view
`VIEW_TYPE_OWNER` | `VARCHAR2(30)` |  | Owner of the type of the view if the view is a typed view
`VIEW_TYPE` | `VARCHAR2(30)` |  | Type of the view if the view is a typed view
`SUPERVIEW_NAME` | `VARCHAR2(30)` |  | Name of the superview

See Also: "DBA_VIEWS" "USER_VIEWS"